EMT Practice Test

1. Question Content...

---

Question1: Where would a Snowflake user find information about query activity from 90 days ago?

Question2: Which command can be used to load data files into a Snowflake stage?

Question3: What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Question4: True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

Question5: What happens when a virtual warehouse is resized?

Question6: What data is stored in the Snowflake storage layer? (Select TWO).

Question7: True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Question8: Which of the following are options when creating a Virtual Warehouse?

Question9: What is the purpose of an External Function?

Question10: True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

Question11: Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Question12: Which of the following statements describe features of Snowflake data caching? (Choose two.)

Question13: What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

Question14: In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Question15: Which Snowflake architectural layer is responsible for a query execution plan?

Question16: True or False: The COPY command must specify a File Format in order to execute.

Question17: Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Question18: Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

Question19: Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Question20: Which type of table corresponds to a single Snowflake session?

Question21: When should a multi-cluster warehouse be used in auto-scaling mode?

Question22: Which copy INTO command outputs the data into one file?

Question23: Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

Question24: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Question25: Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

Question26: What tasks can be completed using the copy command? (Select TWO)

Question27: Which Snowflake layer is always leveraged when accessing a query from the result cache?

Question28: True or False: An active warehouse is required to run a COPY INTO statement.

Question29: What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Question30: Which Snowflake tool would be BEST to troubleshoot network connectivity?

Question31: A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

Question32: A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

Question33: A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?

Question34: What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Question35: Which of the following describes external functions in Snowflake?

Question36: True or False: Snowpipe via REST API can only reference External Stages as source.

Question37: During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Question38: Which feature is only available in the Enterprise or higher editions of Snowflake?

Question39: What are common issues found by using the Query Profile? (Choose two.)

Question40: A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

Question41: A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?

Question42: True or False: Fail-safe can be disabled within a Snowflake account.

Question43: True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Question44: How are serverless features billed?

Question45: Which command can be used to load data into an internal stage?

Question46: How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question47: User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

Question48: The Snowflake Search Optimization Services supports improved performance of which kind of query?

Question49: What is a responsibility of Snowflake's virtual warehouses?

Question50: What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

Question51: What are the default Time Travel and Fail-safe retention periods for transient tables?

Question52: A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

Question53: True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

Question54: What SQL command would be used to view all roles that were granted to user.1?

Question55: What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Question56: A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

Question57: Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Question58: Which of the following describes a Snowflake stored procedure?

Question59: Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Question60: A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

Question61: How would a user execute a series of SQL statements using a task?

Question62: Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Question63: What is the default character set used when loading CSV files into Snowflake?

Question64: What can be used to view warehouse usage over time? (Select Two).

Question65: How often are the Account and Table master keys automatically rotated by Snowflake?

Question66: Which command sets the Virtual Warehouse for a session?

Question67: What happens when a cloned table is replicated to a secondary database? (Select TWO)

Question68: Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Question69: Which of the following compute resources or features are managed by Snowflake? (Select TWO).

Question70: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Question71: Which of the following is a data tokenization integration partner?

Question72: If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

Question73: What is the minimum Snowflake edition required to create a materialized view?

Question74: The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

Question75: Which of the following describes the Snowflake Cloud Services layer?

Question76: True or False: Pipes can be suspended and resumed.

Question77: Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Question78: The PUT command: (Choose two.)

Question79: Which data type can be used to store geospatial data in Snowflake?

Question80: If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Question81: Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Question82: What is the MOST performant file format for loading data in Snowflake?

Question83: Which statement about billing applies to Snowflake credits?

Question84: For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Question85: What is a best practice after creating a custom role?

Question86: True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

Question87: True or False: A Virtual Warehouse can be resized while suspended.

Question88: Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?

Question89: The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

Question90: True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Question91: A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

Question92: Which Snowflake technique can be used to improve the performance of a query?

Question93: A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

Question94: In the Snowflake access control model, which entity owns an object by default?

Question95: Will data cached in a warehouse be lost when the warehouse is resized?

Question96: What are ways to create and manage data shares in Snowflake? (Select TWO)

Question97: What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Question98: A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

Question99: Which Snowflake partner specializes in data catalog solutions?

Question100: What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Question101: Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Question102: Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Question103: By default, which Snowflake role is required to create a share?

Question104: Users are responsible for data storage costs until what occurs?

Question105: Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Question106: True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

Question107: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.